USE [master]
GO
/****** Object:  Database [ShopDB]    Script Date: 02/29/2012 12:26:06 ******/
CREATE DATABASE [ShopDB] ON  PRIMARY 
( NAME = N'ShopDB', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\ShopDB.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'ShopDB_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\ShopDB_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [ShopDB] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [ShopDB].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [ShopDB] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [ShopDB] SET ANSI_NULLS OFF
GO
ALTER DATABASE [ShopDB] SET ANSI_PADDING OFF
GO
ALTER DATABASE [ShopDB] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [ShopDB] SET ARITHABORT OFF
GO
ALTER DATABASE [ShopDB] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [ShopDB] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [ShopDB] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [ShopDB] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [ShopDB] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [ShopDB] SET CURSOR_DEFAULT  GLOBAL
GO
ALTER DATABASE [ShopDB] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [ShopDB] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [ShopDB] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [ShopDB] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [ShopDB] SET  DISABLE_BROKER
GO
ALTER DATABASE [ShopDB] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [ShopDB] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [ShopDB] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [ShopDB] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [ShopDB] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [ShopDB] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [ShopDB] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [ShopDB] SET  READ_WRITE
GO
ALTER DATABASE [ShopDB] SET RECOVERY SIMPLE
GO
ALTER DATABASE [ShopDB] SET  MULTI_USER
GO
ALTER DATABASE [ShopDB] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [ShopDB] SET DB_CHAINING OFF
GO
USE [ShopDB]
GO
/****** Object:  Table [dbo].[Goods]    Script Date: 02/29/2012 12:26:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Goods](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[Brand] [nvarchar](20) NOT NULL,
	[Model] [nvarchar](20) NOT NULL,
	[Price] [money] NULL,
	[Description] [nvarchar](255) NULL,
	[Quantity] [bigint] NULL,
	[ImagePath] [nvarchar](255) NULL,
 CONSTRAINT [PK_Goods] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Goods] ON
INSERT [dbo].[Goods] ([ID], [Brand], [Model], [Price], [Description], [Quantity], [ImagePath]) VALUES (1, N'MULTIZONE II', N'VVU74UMT3AJ', 100.0000, N'dis parturient montes, nascetur ridiculus mus.', 3, NULL)
INSERT [dbo].[Goods] ([ID], [Brand], [Model], [Price], [Description], [Quantity], [ImagePath]) VALUES (2, N'Danrou', N'NVM11XIO1CK', 100.0000, N'eget, dictum placerat, augue. Sed', 8, NULL)
INSERT [dbo].[Goods] ([ID], [Brand], [Model], [Price], [Description], [Quantity], [ImagePath]) VALUES (3, N'AVIZOR', N'BLZ44JCZ0IV', 100.0000, N'urna. Vivamus molestie dapibus ligula. Aliquam erat volutpat. Nulla', 2, NULL)
INSERT [dbo].[Goods] ([ID], [Brand], [Model], [Price], [Description], [Quantity], [ImagePath]) VALUES (4, N'Danrou', N'FWW39HIM5DT', 100.0000, N'fringilla purus mauris a', 10, NULL)
INSERT [dbo].[Goods] ([ID], [Brand], [Model], [Price], [Description], [Quantity], [ImagePath]) VALUES (5, N'AVIZOR', N'TIK76GBM6FU', 100.0000, N'a, malesuada id, erat. Etiam vestibulum', 1, NULL)
INSERT [dbo].[Goods] ([ID], [Brand], [Model], [Price], [Description], [Quantity], [ImagePath]) VALUES (6, N'MULTIZONE', N'RTM28FSF0RP', 100.0000, N'et', 7, NULL)
INSERT [dbo].[Goods] ([ID], [Brand], [Model], [Price], [Description], [Quantity], [ImagePath]) VALUES (7, N'AVIZOR', N'SET33OMW5MG', 100.0000, N'dapibus gravida. Aliquam tincidunt, nunc', 8, NULL)
INSERT [dbo].[Goods] ([ID], [Brand], [Model], [Price], [Description], [Quantity], [ImagePath]) VALUES (8, N'Danrou', N'EWU15KMP7CC', 100.0000, N'vitae risus. Duis a', 10, NULL)
INSERT [dbo].[Goods] ([ID], [Brand], [Model], [Price], [Description], [Quantity], [ImagePath]) VALUES (9, N'MULTIZONE II', N'RPF20LEO3XN', 100.0000, N'neque. Morbi quis urna. Nunc', 4, NULL)
INSERT [dbo].[Goods] ([ID], [Brand], [Model], [Price], [Description], [Quantity], [ImagePath]) VALUES (10, N'MULTIZONE', N'QKN34PEV4DY', 100.0000, N'Nullam suscipit, est ac facilisis', 2, NULL)
SET IDENTITY_INSERT [dbo].[Goods] OFF
